package com.cdtye.itps.cms.mapper.origindata;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.cdtye.itps.cms.dao.origindata.entity.JcjcDetectC1Job;
import com.cdtye.itps.cms.dao.origindata.vo.JcjcDetectC1JobVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface JcjcDetectC1JobMapper extends BaseMapper<JcjcDetectC1Job> {
    /**
     * 1c原始数据管理——自定义分页查询
     */
    IPage<Map<String,Object>> listPage(IPage page, @Param("vo") JcjcDetectC1JobVo vo);

    /**
     * 1c原始数据部门分布情况
     */
    List<Map<String,Object>> deptStatistic();

    /**
     * 线路分布情况
     */
    List<Map<String,Object>> lineStatistic(@Param("vo") JcjcDetectC1JobVo vo);

    /**
     * 检测数据月份分布
     */
    List<Map<String,String>> dataMonthStatistic();

    /**
     * 数据包总大小
     */
    Double sumStatistic();

    Map<String,Object> selectDetail(@Param("detectJobId") String detectJobId);


}
